UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V3p7v7cIwnyVTkNCmuxnPQ175pTRVGejtENunZnJ9b4='
WHERE
key_id = '127aef1d94cadc376809845704a232dc5842752544a729fd385f61d20b61bb8f'
AND (
token = 'V3p7v7cIwnyVTkNCmuxnPQ175pTRVGejtENunZnJ9b4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)