UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JH0QO71rKkKwHG4V6mRXp9EXzES5TB//m1UlxQVYf7A='
WHERE
key_id = 'ca431785f96207fc946395ad06d719cd743395f8c7e97744126e64be7f89acc4'
AND (
token = 'JH0QO71rKkKwHG4V6mRXp9EXzES5TB//m1UlxQVYf7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)