UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qkYbudKq1BGkswiOKRiXrPJ8fYiZ5okwN1ugYLxlYsU='
WHERE
key_id = '5a89944af395a856f166510bc119a4e7455987cb314d7b892aa4a9c942565636'
AND (
token = 'qkYbudKq1BGkswiOKRiXrPJ8fYiZ5okwN1ugYLxlYsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)