UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a27FIuEk0r8pwhMKqAzknMmRniy/uzBBvcCBjhvn2Y8='
WHERE
key_id = '75bc396a26b0a94cd7d463cfb00ad342fb1406d89ebd2864b505b11fdc0c83ce'
AND (
token = 'a27FIuEk0r8pwhMKqAzknMmRniy/uzBBvcCBjhvn2Y8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)