UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '41AA7SpQqn3ONGlGAUDTGE7Xo8wO8rpxXLHIEMAXJyw='
WHERE
key_id = '0f148302286c0f387d399d47b84a96443df5780afe0c9b7e3de048184a57f554'
AND (
token = '41AA7SpQqn3ONGlGAUDTGE7Xo8wO8rpxXLHIEMAXJyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)