UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NmQHUNaD+fp4iK0hZ8j3ZTGzWGQ2c7R8ghoaaxlzag='
WHERE
key_id = '62c04be347e1f302ad7b2ef401f53c78c84212d32e67d98e4a9f9a4a4f302ac7'
AND (
token = '6NmQHUNaD+fp4iK0hZ8j3ZTGzWGQ2c7R8ghoaaxlzag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)