UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NAUpgKGGYe7XzKpt0mz7R1+4kAcy7Pxu+8W1bPFhAd8='
WHERE
key_id = 'de0bf0b4b0babfa21437dad8248c8da6c2f1439aaa92b2b0ce18743cf32782d4'
AND (
token = 'NAUpgKGGYe7XzKpt0mz7R1+4kAcy7Pxu+8W1bPFhAd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)