UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3oQicOlVSJflOcvv1yECER1aWg3s8ruU/4VRvB0eM4w='
WHERE
key_id = 'ca9b7470880c68440536b9f32d7f64c77b1f0e8ed9b84daced2d65530b3fd487'
AND (
token = '3oQicOlVSJflOcvv1yECER1aWg3s8ruU/4VRvB0eM4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)