UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnT5gzX49FuOuLYp0/a7iaDqFUG6AZ/9YvoroC3wcTE='
WHERE
key_id = '103c37b61e1e759712bb841c09e499202c9dd999de8a1db6563326b0ec6542ee'
AND (
token = 'HnT5gzX49FuOuLYp0/a7iaDqFUG6AZ/9YvoroC3wcTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)