UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dC9eIzScPLILpcOTJaScIX+XHXY/qVzwRduM1HgiI5E='
WHERE
key_id = '7845b3b5054c0b7de73c48fcc9d8c955dc638cd555d075019294c42495f9414d'
AND (
token = 'dC9eIzScPLILpcOTJaScIX+XHXY/qVzwRduM1HgiI5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)