UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aEEnA7Ush1ScX8G8kvMXUmYLCQ5neFDeesNjt5yHd3s='
WHERE
key_id = 'bbe6f0da7fd540b66ee11d26440fb1acae4cbf862a46ab909c1019147230ea88'
AND (
token = 'aEEnA7Ush1ScX8G8kvMXUmYLCQ5neFDeesNjt5yHd3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)