UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DiFem6MrSEelq56tI+4WxKP4J5gSKaocM7ANItcoOis='
WHERE
key_id = '49ba824be03f8dacdb76b024c8b68f32105fc5bf247c90f26046f49295b37ca5'
AND (
token = 'DiFem6MrSEelq56tI+4WxKP4J5gSKaocM7ANItcoOis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)