UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5qSNXjzakTCQ6R/W4b7vZHtZdkLcq9deYhw+iPVfe1U='
WHERE
key_id = '6bb7654a7779684ebbd80f0fe67aaa836c03ec85fef4902ca45ecfd69199c365'
AND (
token = '5qSNXjzakTCQ6R/W4b7vZHtZdkLcq9deYhw+iPVfe1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)