UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzT7gqmIt6wczzjmvkNPZKMWkpmOtadRMEc6n7zmfpE='
WHERE
key_id = '6e3e58567a31ac0e23a572914748788f5b3643bb1cf311bc05c447463b84593d'
AND (
token = 'zzT7gqmIt6wczzjmvkNPZKMWkpmOtadRMEc6n7zmfpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)