UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdyEszF/sVOm6XV83wJm0PiuLK4H4cDhyhaUuCow8xc='
WHERE
key_id = '09659e3f549d1213548094fccea431ecbcc11740782906e314317ad5d06ca32c'
AND (
token = 'QdyEszF/sVOm6XV83wJm0PiuLK4H4cDhyhaUuCow8xc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)