UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r/S/VXBE9LuKF0YlaiRzpREuMZzP4JORBOM8jH9SiDQ='
WHERE
key_id = '0e4ec33559a9e0b31b48a8599379f22c02956544979d7ae2e832a4973328dd6a'
AND (
token = 'r/S/VXBE9LuKF0YlaiRzpREuMZzP4JORBOM8jH9SiDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)