UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dFZd50rsVc+Rv7aNlB2l+9+Tc3e2CkQ/IMOUt7jXjoA='
WHERE
key_id = 'c827eaa5b2909ef1d58a36deee9b7c7f710fbc939215f572e5a6eaa5b29e1321'
AND (
token = 'dFZd50rsVc+Rv7aNlB2l+9+Tc3e2CkQ/IMOUt7jXjoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)