UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EmXs/1CDYIvDt9luhClmEaLf9tqv0U4H70rEquPvEhU='
WHERE
key_id = '46498ebd3d33fb72b8b69f314e743adf5ff8b693fae0f1705e954c5c490fe65e'
AND (
token = 'EmXs/1CDYIvDt9luhClmEaLf9tqv0U4H70rEquPvEhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)