UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vtQxqxc/K1+Y2MP6RSAlpAzI9RzTVfQSB7Wl1io/DSA='
WHERE
key_id = '0cdacf2636b8cd1626bd9ef48d73d629a1c9d7ec8718ce3ac33e4c27ea9ecb2e'
AND (
token = 'vtQxqxc/K1+Y2MP6RSAlpAzI9RzTVfQSB7Wl1io/DSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)