UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yqxHufd2xV+x/U7bl2JIe0YuSIsWI9htMbkEd9SLnI='
WHERE
key_id = '47ac370f0f9377c2242c52c2d78dd4d0f15b1f2a933d60e4bbe9eafcf24d8f84'
AND (
token = '9yqxHufd2xV+x/U7bl2JIe0YuSIsWI9htMbkEd9SLnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)