UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dgQEcwVJbtD2442JlAwAHSTCzIbkOvV7qyPNpG767u4='
WHERE
key_id = 'cf8a70c5d8adfe6e0e33bd624dc169a592eaef583086f5051b2db6fa3bddd103'
AND (
token = 'dgQEcwVJbtD2442JlAwAHSTCzIbkOvV7qyPNpG767u4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)