UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4rIgNQg8VdHOE4DdQdE7Aag0WpEvRkoKNkgKp0snPng='
WHERE
key_id = 'a5a9d057528243b35e92f5208f616fda223a313928f879b9bfd11b4112aa3d41'
AND (
token = '4rIgNQg8VdHOE4DdQdE7Aag0WpEvRkoKNkgKp0snPng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)