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