UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qs7XHKSXGxIYz9/IasLAAC9U6taC/8UafSqmH2NYQFw='
WHERE
key_id = 'b023c0246fdf6aa3f4967a75589bb9f03207f4a26b4326d98ccc8e70a44e87c0'
AND (
token = 'qs7XHKSXGxIYz9/IasLAAC9U6taC/8UafSqmH2NYQFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)