UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm1wjAmIFoU3YPQuLm5xZIY5B3KV63OQhGF45Z3iCZKE='
WHERE
key_id = 'c1bbce5c23d610e4438dab8e0cff600e78127c0a2da0dd4fd61cccbfb33e2232'
AND (
token = 'm1wjAmIFoU3YPQuLm5xZIY5B3KV63OQhGF45Z3iCZKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)