UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bS7rUnK8dhv4lwhd+JssQofOBP+ck8er9RJTJ/+V18A='
WHERE
key_id = 'e243c6883571cbc7a3d5715e35d791548d0309a22a874f5df76a228c68b7a092'
AND (
token = 'bS7rUnK8dhv4lwhd+JssQofOBP+ck8er9RJTJ/+V18A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)