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