UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bhM3TJ8F+j001WUzRX5LbPsNIz83O/eH1kLDccW8rTg='
WHERE
key_id = 'e1bf37036a6dca34b05f484814b140fa066386020732b28b6796411b7a6667bf'
AND (
token = 'bhM3TJ8F+j001WUzRX5LbPsNIz83O/eH1kLDccW8rTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)