UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VG6rE1oFu2+xqiGl2rinPbxqgmG0ROIKYMysf3gEkvM='
WHERE
key_id = '4596d234a36d9cbce5200fe7f1ff8844ed64089c535790848a18163396bda56b'
AND (
token = 'VG6rE1oFu2+xqiGl2rinPbxqgmG0ROIKYMysf3gEkvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)