UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LX8Co7rgmTwkh9moxDNWvgorxjaFAE/Atm9xWT9hRac='
WHERE
key_id = 'c1e8686522c4a52b98cffcf96d11fddf8f39536c258454ccbb1929dc86aa6e13'
AND (
token = 'LX8Co7rgmTwkh9moxDNWvgorxjaFAE/Atm9xWT9hRac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)