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