UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XyUgS2c3X5pFIIgtt8nAHc+80zmbLyg6RjsAJBfHB4='
WHERE
key_id = 'a471bd2019d2ff87503290dcbb00f23591ea7da54126146725d170be1a3aeb68'
AND (
token = '6XyUgS2c3X5pFIIgtt8nAHc+80zmbLyg6RjsAJBfHB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)