UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvZrcBFGlJW7M/zeSVMqLwp1y5WEHPKgBiD8uae96V0='
WHERE
key_id = '8dfef809c0ecc142faf8797bfdbc13fa1cbe61a7c82a3200cb78faaac91b147c'
AND (
token = 'VvZrcBFGlJW7M/zeSVMqLwp1y5WEHPKgBiD8uae96V0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)