UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIf2C73NA+aswf/uFP/ErY429vKwHb6kuMIHpKMXg4I='
WHERE
key_id = 'e560643076a432f08de52492a67c698d2fdc8a5ee25ffcc3ec69080847e65336'
AND (
token = 'zIf2C73NA+aswf/uFP/ErY429vKwHb6kuMIHpKMXg4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)